FLUX ANALYSER - TOOLS ADD-ON
============================

Three little jobs you can run against the FLUX Analyser workbook:

    Build the PowerPoint     turns the whole report into an 11-slide deck
    Save the workbook        saves it without switching windows
    Clear the pasted data    empties the Data tab, ready for a fresh export

You run them by double-clicking them in this folder. The Report tab has a
button - OPEN THE TOOLS FOLDER - that brings you straight here.


WHY IT IS NOT ONE CLICK
-----------------------
  Because Excel will not let a spreadsheet start a program, and there is no
  way around it that does not involve macros. Click a link to a .cmd file and
  Excel asks Windows which program opens it, is told the file IS the program,
  and refuses with "No program is registered to open this file."

  We could ship a macro-enabled workbook instead. We would rather not: an
  .xlsm arrives with a security banner, plenty of workplaces block them
  outright, and you would have to take our word for what the macro does.
  Everything here is plain text you can open in Notepad and read.

  So: one click to the folder, one double-click on the job. Two clicks.


WHAT YOU NEED
-------------
  Windows, Microsoft Excel, and Microsoft PowerPoint installed.

  The tools will not run on a Mac or in Excel for the web. Everything else in
  the workbook does - the analysis itself needs nothing but Excel.


SETTING IT UP  (once, about ten seconds)
----------------------------------------
  1. Extract EVERY file in this zip into one folder.
     Somewhere ordinary is fine - Documents, or your desktop.

  2. Double-click  Setup.cmd

     It does two things: clears the "downloaded from the internet" mark off
     the scripts, and writes this folder's real path into the button. That
     second part matters if the folder ends up inside OneDrive or SharePoint,
     where Excel reports the folder as a web address instead of a disk path.

     Windows may warn you about running a file from the internet. That is
     expected. Setup.cmd is four lines and you can read it in Notepad.

  3. Open FLUX Analyser.xlsx, go to the Report tab, and the button sits just
     under the blue banner.

  If you ever move the folder, run Setup.cmd again.


USING IT
--------
  Paste a FLUX export into the Data tab. Then either click OPEN THE TOOLS
  FOLDER in the workbook, or just open this folder yourself, and double-click

      Build the PowerPoint

  The deck takes about a minute. Excel and PowerPoint both need to stay open
  while it runs, but you can carry on working in other windows - nothing is
  copied through the clipboard.

  The finished deck lands in this same folder, named for the period it covers,
  for example "FLUX Report - 10 Aug 2026 to 6 Sept 2026.pptx". It is a normal
  PowerPoint file: every table, chart and heat grid is a real PowerPoint
  object, so you can edit, restyle and re-brand any of it.


CLEAR THE PASTED DATA
---------------------
  Removes only the rows you pasted into the Data tab. The formulas, the helper
  columns and every report tab are left exactly as they are, so you can paste
  a fresh export straight over the top. It asks before it does anything, and
  tells you how many rows it is about to remove.


IF SOMETHING DOES NOT WORK
--------------------------
  The button opens the wrong place, or nothing
      Run Setup.cmd again. That is almost always it.

  Build the PowerPoint seems to do nothing
      Every run writes a log. Press Windows+R, paste this, press Enter, and
      send us what it says:

          %TEMP%\flux-deck-trace.log

      An empty or missing log means the script never started - usually the
      files were extracted into different folders.


WHAT EACH FILE IS
-----------------
  FLUX Analyser.xlsx          the workbook
  Setup.cmd                   run once; points the button at this folder
  Build the PowerPoint.cmd    double-click to build the deck
  Save the workbook.cmd       double-click to save
  Clear the pasted data.cmd   double-click to empty the Data tab
  flux-*.ps1                  the scripts themselves - plain text, readable

  There are no macros anywhere. The workbook is an ordinary .xlsx, which is
  why it opens without a security banner.
